package cn.neusoft.edu.his.demo.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import cn.neusoft.edu.his.demo.po.PatientDoctor;
import cn.neusoft.edu.his.demo.po.Personage;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

@Mapper
public interface PatientDoctorMapper extends BaseMapper<PatientDoctor> {
    @Select("select p.*,d.*,f.*,m.*,l.* from patient_doctor p,doctor_work d,department f,doctorfe" +
            "" +
            "e m,doctor l where p.doc_id=d.doc_id " +
            "AND p.depart_id2=f.department_id " +
            "AND p.patient_id=#{patientId} " +
            "AND p.day=d.day "+
            "AND d.fee_id=m.fee_id "+
            "AND p.doc_id=l.doc_id")
    List<Personage> getpersonage(Personage personage);

}
